Forum Discussion
Excell formula help
Hi, I would like help to merge multiple rows and columns into one continuous row. Eg - all data to be spread across A1,B1,C1,D1,E1,F1,G1,H1,I1,J1,K1 etc FROM: B4,C4,A6,B6,A7,B7,B8,A9,B9,A11,B11 - Is ...
Thanks for that. I got close but then pivoted on the wrong column (I think I selected the ID rather than the attribute column I wished to split into fields). The outturn was an error so I reverted to plan B and used a sequence of outer joins to build the output table. Data analysis is definitely not my strong suit; I can't remember ever having a significant data set to slice and dice so the skills come slowly.
Peter, I published it since started doing the task before seen your variant. At the same I think more variants in discussions the better, it's always useful to check an issue from different points of view.
Your strong point is analysis. That's only bit more practice to add the word "data" in front.