| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change Data from column b into row based on value in column a
I have a list in excel with suppliers in column A (over 1000 rows) and
details about that supplier in column B. however, for some of the suppliers there are multiple lines because there are multiple details. How do I change the multiple rows into one row per supplier with the details spread out from Column B on? Ex. Current Setup Supplier Detail A 1 A 2 A 3 Needed Setup Supplier Detail A 1 2 3 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making a new column based on data in an existing column | Excel Discussion (Misc queries) | |||
| Need to write function that will change column width based on a condition | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| How do I change column data based on dynamic (rolling) dates? | Excel Discussion (Misc queries) | |||
| Resetting values based on change in cells of other column | Excel Discussion (Misc queries) | |||
Threaded Mode
