Log In
Register
Home
Active Member
August 7, 2024
Offline
Hi,
I would like to ask for help with generating a dynamic offset function (my guess) to do some data rearrangement. I want to create a heatmap (attached 1st picture) but the data I get for that are in unsuitable format. I need to put 19-row-long pieces of one column horizontally next to each other (attached 2nd picture). I hope the picture is informative enough otherwise I can try describing it better.
The issue is not the "x-y axis" data (letters and numbers 1-1465), that I can do. But I don't know how to reorganize the table content data.
Does anyone please have any idea how to create such a function that would reorganize segmented data from one column into several columns?
Thank you very much,
Tomas
July 16, 2010
Offline
Hi Tomas,
You can use Power Query or PivotTables to pivot the data into columns for 1, 2 and 3.
If you share an example file, we can show you how.
Mynda
Active Member
August 7, 2024
Offline
Hi Mynda,
That would be great - thank you so much!
I attached the file to my first post, but the truth is, I cannot see it posted there. I am trying to add it to this post then. (It is a bit weird because I see it uploaded, it is accepted .xlsx format, I pressed "start", but it is not displayed in the file uploads list.)
Thank you for your suggestions to my previous post,
Tomas
VIP
Trusted Members
December 7, 2016
Offline
Hello,
You get the data in correct format. Not sure if all columns are needed though.
See attached file for two methods you can use. The PivotTable being the quickest and easiest.
As you will notice, I shortened your example data a bit.
Br,
Anders
Active Member
August 7, 2024
Offline
Dear Anders,
Amazing, that is exactly what I needed to get. Thank you so much for your help! I will check the PivotTable procedure you have applied there to learn how to do that.
Best wishes,
Tomas
1 Guest(s)
