Hello.
Please reference the attached file with three sheets as current (sheet1), unpivoted (sheet2) and final (sheet3).
This has to be done in PQ, because the unpivoted data set produces over 1 million records.
Thanks!
Hello.
Please reference the attached file with three sheets as current (sheet1), unpivoted (sheet2) and final (sheet3).
This has to be done in PQ, because the unpivoted data set produces over 1 million records.
Thanks!
Take a look at the table at cell A5 of the Final sheet.
Not yet generalised/flexible. No handling differerent numbers of columns in source data yet.
Could do with a bit more sample data.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Well, thank you kind sir. Please see attached expanded dataset.
See the attached at cell A1 of the Final sheet.
Only 5 rows big at the moment to save space, so needs refreshing to see the full list.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
I tested it on the full dataset, and it looks to be performing flawlessly. Thank you!
Hi p45cal.
Would you be able and willing to offer a variation of your code to extract an unpivoted list of distinct Key | Value(s)?
Thanks!
See the sheet Table2 in the attached.
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Thank you, Sir.Originally Posted by p45cal
Posting Permissions
Reply With Quote
