Hello,
I have a dataset I need to restructure for further analysis later on. I suspect there must be something related to transposing my data somehow but I cannot figure out how I can do that.
Here I attach a small subset of my whole dataset "my_data" and desired structure "new_structure".
Thak you very much in advance!
My data is an xls file. I can't open that file.
Please also add the result and dataset in 1 workbook (eventualy in 2 worksheets).
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Changes done and new file "data.xlsx" uploded.
Maybe with a a pivot table.
See the attached file.
Thanks for your suggestion.I had tried this earlier but it is important that the first column only contains my long time series and new columns are created for each age and treatment. Any alternative?
Maybe this different pivot layout
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks