ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Major Sorting Issue (https://www.excelbanter.com/excel-discussion-misc-queries/48285-major-sorting-issue.html)

noobdisaster

Major Sorting Issue
 

Ok, this will not be easy to explain, but I will try my best. I have
data that is listed something like this:

Job=123
time=345
name=john doe
department=payment
blue
green badge

This data is all in one column and there may be more lines (not all
entries have four rows as provided in the example, some may have 5, 10
13, etc.) of data, and all the data is not necessarily in the same
order. There may be hundreds of these "packets" (for lack of a better
term). I would like to be able to split the data into columns.
Example:
JOB TIME Name Department
123 345 John Doe payment

Any ideas on how this can be accomplished?


--
noobdisaster


All times are GMT +1. The time now is 06:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com