Wednesday, February 12, 2020

Convert a Series of Column Pairs into a Table



Got a table that is a series of pair column attributes? Like one column is Date and the right next to it is Quantity, but instead of one pair of this Date-Quantity column pairs, you have multiple ones? How are you supposed to do any proper analysis or charting on this? If this was a small table, copy/paste/transpose might work, but if it was a larger table or something you'd have to convert on a recurring basis it would get tedious. Well that's where Power Query comes in to save you...see the video to learn more

No comments:

Post a Comment