Generate a one to many for the same table

[TonyWebCloud75]

I have unstructured data like so in one column - and I would like to split it out:

TABLE 1

RawData

519

ABC

XYZ

520

AAA

BBB

CCC

DDD

So, I need to write some DAX to convert it into a 1 to many relationship. Generate a TABLE 2 (many) table, while maintaining the relatinship:

TABLE 1	..........	TABLE 2	...
RawData		ChildData		RawData
519
		ABC		519
		XYZ		519
520
		AAA		520
		BBB		520
		CCC		520
		DDD		520

Is this possible?

[amitchandak]

@TonyWebCloud75 , Check if file after signature can help. Check two tables in power query

[TonyWebCloud75]

Amazing sir! Well done.  What if the column as numbers and letters, how would we extract it?