#1
|
|||
|
|||
How to merge multiple Columns with the same Name?
How do I get something like in Excel? I've attached the photos below |
#2
|
||||
|
||||
Hi
Please post a sample sheet. Pictures cannot be worked with. I have a Power Query solution ready for you Thx PS courtesy is always appreciated. "Hello" or " Thanks" are not considered as rudeness on the board
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
An option to do this using worksheet formulas only!
Current design is for up to 7 phone numbers per person. |
#4
|
||||
|
||||
Here is a simple solution using Power Pivot
Excel: Reporting Text in a Pivot Table - Strategic Finance |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge with Fields extracted from ROWS instead of COLUMNS or transpose of typical mail merge | djrexy | Mail Merge | 1 | 05-20-2020 04:04 PM |
How to Split Dynamic merge field values to multiple columns | Naveen Dhanaraj | Mail Merge | 17 | 02-19-2020 01:18 AM |
Merge cells (multiple rows) causing loss of formatting within merge area | cglenn | Word Tables | 0 | 08-09-2019 09:48 AM |
How do I mail merge records into table columns with more than one merge field? | tech123 | Mail Merge | 1 | 04-26-2017 07:13 PM |
I need to count based on multiple criteria in multiple columns | rachaels54 | Excel | 1 | 04-18-2017 03:20 PM |