Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Transpose rows to columns

  I've tried all the suggestions in the community and not getting desired result. I don't want to summarize the data. I'm trying to get this...     from this... where the fields are in one...
Need Help
az38's avatar
az38
Community Champion
6 years ago

Hi Anonymous 

go to the Power Query Editor, add a Custom column

Number.RoundUp([Index]/4)

then remove Index column

then pick field name column, press Pivot Column in Transform ribbon, set parameters as below

then remove Custom column

 

as a result you will get your desired table

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi az38 Saz38, sorry for delay to reply.

 

thank you for the tip on using pivot and customer column. It worked on moving the field names to columns and populated the values on one of the fields (loanid). I think how the data is arranged is a bit off. The values for loanid looks good, however the other values, doctype, batchid, etc. is populating with mostly nulls and incorrect values. It's like when it was pivoting, some of the values got out of order. I'm looking at the data and see if the values are matching up with the fields correctly, and will run it again.