|
|
|
|
#2
01-06-2022, 12:12 AM
|
||||
|
||||
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
__________________
Using O365 v2503 - 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
01-06-2022, 05:25 AM
|
|||
|
|||
|
An option to do this using worksheet formulas only!
Current design is for up to 7 phone numbers per person.
|
|
#4
01-13-2022, 06:14 PM
|
||||
|
||||
|
Here is a simple solution using Power Pivot
Excel: Reporting Text in a Pivot Table - Strategic Finance
|
|
|
|
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 |
Windows 10 
Office 2016
Hybrid Mode