Power Query: Transform long list data source to table

[Cpt_Pirx]

Hello,
I have a csv data source with the data structure like:

A: customer1_related_info1
B: customer1_related_info2
C:customer1_related_info2
..
ZZ:customer1_related_info50
A: customer2_related_info1
B: customer2_related_info2
C:customer2_related_info2
..
ZZ:customer2_related_info50
.
.
A: customer750_related_info1
B: customer750_related_info2
C:customer750_related_info2
..
Z:customer750_related_info50

Is there a set of transformation in PQ I can use to quickly transform this into, or is theer a better tool for that?

A B C .. ZZ
cust1_info1..
cust2_info1..
cust3_info1..

Many thanks !

 

[6677028]

I don't understand what you mean.

 

[Cpt_Pirx]

Hi,
In the meantime. I've found a solution to my problem, if anyone has similar issues pls check:

Convert Flat List to Table in Power BI; Pivot Without a Set Key Column Using Power Query

The scenario I am explaining today is a very specific use case, However, I have seen examples similar to this happens very often. It happens that you get a text or Excel file with values written in a flat list structure, and that needs to be changed to a table format. Usually, this process can...

radacad.com