Forum Discussion
Parsing Data from One Column to Multiple Columns
Hi all… Looking for advice I’m trying to find a quick way to sort data from one column into multiple columns in Excel 2013. Data appears in the first column with a single record on multiple rows. A...
TimStrickland You ask for a quick way. If you don't mid a solution that is both quick and dirty, please see attached and try to apply the same principle to your real data.
Riny_van_Eekelen, thanks for responding. In the attachment, I see you have visualized what I want to accomplish. I’d like to know if there is a function/formula or macro that allows me to automate the sorting of data. Do you have any idea how to do it?
TimStrickland I'm not a VBA/Macro person, so I would go for PowerQuery if I were to automate this. You mention to be using Excel 2013, so you'd have to install the PQ add-in and learn PowerQuery. Neither learning VBA or PowerQuery is going to be a quick. It will take some time.
Perhaps someone else here can write a macro for you that is easily adopts to your real life (and perhaps changing) data.
- Unfortunately, the data is on a corporate laptop and I’m not easily able to justify to my IT department downloading/installing PowerQuery software. But thank you very much for the suggestion.