Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2022, 06:13 PM
vgnapi vgnapi is offline How to merge multiple Columns with the same Name? Windows 10 How to merge multiple Columns with the same Name? Office 2016
Novice
How to merge multiple Columns with the same Name?
 
Join Date: Jan 2022
Posts: 1
vgnapi is on a distinguished road
Default How to merge multiple Columns with the same Name?

How do I get something like in Excel?



I've attached the photos below
Attached Images
File Type: png Turn This....PNG (22.4 KB, 31 views)
File Type: png ....To This.PNG (11.2 KB, 28 views)
Reply With Quote
  #2  
Old 01-06-2022, 12:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to merge multiple Columns with the same Name? Windows 7 64bit How to merge multiple Columns with the same Name? Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

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
Reply With Quote
  #3  
Old 01-06-2022, 05:25 AM
ArviLaanemets ArviLaanemets is offline How to merge multiple Columns with the same Name? Windows 8 How to merge multiple Columns with the same Name? Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

An option to do this using worksheet formulas only!

Current design is for up to 7 phone numbers per person.
Attached Files
File Type: xlsx PhonesList.xlsx (19.0 KB, 9 views)
Reply With Quote
  #4  
Old 01-13-2022, 06:14 PM
Alansidman's Avatar
Alansidman Alansidman is offline How to merge multiple Columns with the same Name? Windows 10 How to merge multiple Columns with the same Name? Office 2019
עַם יִשְׂרָאֵל חַי
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 79
Alansidman will become famous soon enoughAlansidman will become famous soon enough
Default

Here is a simple solution using Power Pivot

Excel: Reporting Text in a Pivot Table - Strategic Finance
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to merge multiple Columns with the same Name? 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 merge multiple Columns with the same Name? 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 to merge multiple Columns with the same Name? 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:20 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft