Excel Field Data pipe delimited with many fields inside

M

markman2

New Member
Joined
Nov 13, 2009
Messages
12
I have a lot of field data in a row that's in format:


Color: Red|Title: Red Shirt|Date: 2015|Medium: cotton|Size: M|
Title: Blue Dress|Date: 2014|Price: 55|Size: M|
Color:Green| Type: New| Size: G| Title: Green Shirt|


Here, in my data, there are many rows with new fields. There are many fields that i do not know, and the data is very big. I want the data to be neatly sorted as fields where the descriptor (such as Color, Title, Date. etc) from the data becomes field headings.

Any suggestions how i can get this done?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
You must log in or register to reply here.

Similar threads

F
  • Question Question
Custom search bar - Creating a front end for My Sold Research Tool.
Replies
0
Views
198
frewert
F
A
  • Solved
Calendar form cancel button passing data to worksheet
Replies
7
Views
1K
AndyEd
A
C
  • Solved
Excel 2016 32bit VBA Pulling info from Website to Sheet
Replies
2
Views
1K
CrashOD
C
D
  • Question Question
Find and Remove Specific Text with VBA
Replies
4
Views
2K
Fazza
F
L
  • Question Question
VBA to Copy data from many workbooks to one workbook
Replies
8
Views
1K
mumps
mumps

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top