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, 23 views)
File Type: png ....To This.PNG (11.2 KB, 20 views)
Reply With Quote
  #2  
Old 01-06-2022, 12:12 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now 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,527
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
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: 656
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
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, 5 views)
Reply With Quote
  #4  
Old 01-13-2022, 06:14 PM
Alansidman's Avatar
Alansidman Alansidman is online now How to merge multiple Columns with the same Name? Windows 10 How to merge multiple Columns with the same Name? Office 2019
Mountain Maven
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 50
Alansidman is on a distinguished road
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:50 AM.


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