Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have data that is returned from an AS400 query that I can transfer into
Excel. The A column lists all products that are found in the return from my query. A typical array would be like: A1 = Product 1 / A2 = Product 2 / A3 = Product 2 / A4 = Product 2 / A5 = Product 3 / A6 = Product 3 / A7 = Product 4 / A8 = Product 5. The reason for the differing number of occurances might be store related. Product 1 is in a single store, therefore requiring only 1 row of data. Product 2 is found in 3 stores and therefore I need all 3 rows of data. etc. In the above example, I'd like to use and Excel function, argument, and/or macro thas has the effect of inserting 2 blank lines between Row 1 and Row 2, moving the Row 2 contents to Row 4. Then I'd like the functionality to spot the next product name-change and insert 2 rows there, etc. all the way to the bottom of the data. I'd wind up with; Product 1 Product 2 Product 2 Product 2 Product 3 Product 3 Product 4 My sincere thanks if you can show me how to do this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to chart a single column of values similar to a GROUP BY | Charts and Charting in Excel | |||
Sum column values that contains text &/or dates | Excel Discussion (Misc queries) | |||
Pivot Table (vlookup 2 column text values, return 1 value) | Excel Discussion (Misc queries) | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |