I gather that what you are wanting to do is transpose the data from reading down to reading across? That is, change something like
1
-
2
-
3
to
1|2|3 ?
If that is the case - and you need to make sure that every group of information has the same number of lines for this to work (you can't have some people with addresses that take up 2 rows, say, and other that take up 3 rows) - then get this free add-on for Excel: ASAP Utilities
It has a large number of built in functions and works like a charm, and one of those is in the section Columns and Rows, Advanced Transposer (screenshot here.)
Using this, you just say how many columns to change your one column into.
We get sent a simple excel doc that needs data to be input into a seperate excel sheet.. is there a way to automate this process and put the correct data in specific field?
You have given me almost no idea of how the data in your "simple excel doc" is laid out, nor how it differs from how you want to have it in the long run, so I can't tall you how to do it right now.
It is almost certainly possible to do what you ask, but I need to know more.
Could you post a file with (fake) data as you receive it and also with a second worksheet that shows how you need to have it laid out?
Will the data from the excel workbook you receive by e-mail always go into the same separate excel workbook?
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!