Forum Discussion

Helper III

5 years ago

Transpose of table doesn't work.. Says too large data.

Hi Experts Situation: I have about 60,000+ IDs and I have one of these tables, with each of these IDs in rows repeated about 30 times as key and values. Objective: To make into columns ID and ...

Community Champion

5 years ago

Please find the project file and try it.

Change the source file.

I am trying to sort out the date format requirement and let you know.

If my answer solves your requirements, mark as SOLUTION.

Find the pbix file - https://drive.google.com/file/d/1cZ4fRc957rS8jQghU7nJMGc3Onm9hqN-/view?usp=sharing

acerNZ

Helper III

5 years ago

Thank you PijushRoy I will wait for Date stuff and executed your solution and I got the concept. When re-doing it, I have some issues may be I create seperate thread.

Forum Discussion

Transpose of table doesn't work.. Says too large data.

Related content

Help Transposing

Transpose data

Transpose Title Row ONLY

Transpose/ Transform Rows to Columns

Pivot/ transpose