|
|
#1
06-17-2015, 03:27 PM
|
|||
|
|||
Data Arrangement
Hi all,
I'm looking for a formula or a way in which i can show a product (i.e A) then lookup all the region and display them in the same row. Is there a way to do that? I even consider to concatenate all regions in a single cell. My workbook has a few thousand line therefore manual input is not ideal. Attached is the sample. Thanks, Haha 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to replicate, consolidate and count cell data in excel for data consoldation. | Loran | Excel | 7 | 06-05-2014 01:07 AM |
| How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
| Edit Data Source- Linking template charts to new data | lbf | PowerPoint | 0 | 10-28-2011 12:19 PM |
 Bothsided Text Arrangement - NOT working
|
Sleeper | Word | 1 | 07-26-2011 04:35 PM |
| Powerpoint: adding data to trend lines w/o data labels | HaiLe | PowerPoint | 0 | 04-11-2011 09:21 AM |
Windows 8 
Office 2010 32bit
Threaded Mode