How do I copy from a form and put into correct columns

[windley]

Please help

I am trying to put this kind of text into a excel spreadsheet and I have no idea how to do it, I would like to put Quotation ID QuotationType etc to be the headers but then the data next to it I would like to put into rows underneath. When I try and copy it all goes into one cell.

Quotation ID XXXX
Quotation Type Moving Few Items
Name Rod
Phone 1 XXXX
Phone 2
Email XXXX
Contact me

Move From
Street
Suburb Camberwell
State Victoria
City / Town Camberwell
Postal Code
Resident Type
Number of bedrooms
Packing Requirement

Move To
Street
Suburb Lismore
State New South Wales
City / Town Lismore
Postal Code
Anticipated moving date Wednesday, October 05, 2011


More Details
MoreDetails 1 x steel four wheel drive bullbar, approx 45kg

[Blake 7]

upload what you have and describe what you want. it may juist be a text to columns issue

[windley]

Sorry Blake I am unsure what you mean by upload what you have decribed, I am new to this forum do i upload a file or something?

[Blake 7]

upload your spreadsheet > go advanced > manage attachments (this is so people do not have to mock up your senario) then describe the before and after ie what are you expecting the result to look like.

As i am not entirely sure what it is you want to do at the moment!

[windley]

Ok Blake, I think i have done this correctly.

[royUK]

What kind of form do you mean?

[windley]

Hi RoyUK, i have put my uploaded what I think i am talking about, basically i want to copy from my email I would like the date to come under the heading horizontally rather than vertical down the page

I hope that this make sense

[Blake 7]

a few questions:

The tab - "what i want it to look like" does NOT have the following headings from col a of "when i copy and paste" tab

is this correct?

Suburb
State
City / Town
Postal Code
Resident Type
Number of bedrooms
Packing Requirement

Move To
Street
Suburb
State
City / Town
Postal Code
Anticipated moving date


More Details
MoreDetails


Question 2

Do you copy one record at a time or are cols b through whatever usually populated with records. Basically it looks like your data is exorting the wrong way round.

Where does your raw data come from? you said form? what form?

[royUK]

maybe this earlier post will help

[windley]

a few questions:

The tab - "what i want it to look like" does NOT have the following headings from col a of "when i copy and paste" tab

is this correct?

Yeah sorry bout that, i do need all the columns


Question 2

Do you copy one record at a time or are cols b through whatever usually populated with records. Basically it looks like your data is exorting the wrong way round.

Where does your raw data come from? you said form? what form?

ok, what i do at the moment is I receive a lead from my lead company however it isn't in CSV format and I have asked them and they can't send them through to me in CSV, so what i thought i would like to do is copy the lead and paste in my excel spreadsheet each time I receive a lead, therefore I would only need the headings one across the top of the page and then each time i press paste I would like the data from the lead to go into the right columns across the page.

If it makes it easier I could email you a copy of what comes through to me from the lead company

Regards Jodie

[royUK]

Have you tried adapting the code that I posted the link to?

[windley]

Thanks Roy, but I don't understand codes.

I thought it would be an easy copy and paste but it is quite difficult: