Combine Multiple Rows into One Row in Excel | Comprehensive Tutorial

Struggling with combining multiple rows into a single row in Excel? Look no further! 🚀

Combining multiple rows into a single row in Excel can be accomplished through various methods, depending on the specific needs of your data and the version of Excel you are using. For versions prior to Excel 365, you can use formulas like CONCATENATE or "&" to merge text. For Excel 2019 and later, the TEXTJOIN function is essential for this task! PowerQuery is another powerful solution.

Remember, the key is to understand the structure of your data and the outcome you wish to achieve. With a step-by-step approach, you can master these transformations and streamline your data management in Excel.


00:00 Introduction
00:48 Combine List of Text
02:47 Combine Rows with an Identifier
05:53 Combine Rows with Multiple Identifiers
07:58 Combine Multiple Columns
11:02 Combine Multiple Columns Another Way
12:58 PowerQuery

[namrathamyneni]

Amazing! never knew life would be much easier. thanks a ton!!!

[manmohansingh]

A great tutorial although it does not answer what I was looking for. I have an Excel table of BP readings (4 times a day) like this:

Date1 Time1 Diastolic1 Systolic1 Pulse1
Date1 Time2 Diastolic2 Systolic2 Pulse2
Date1 Time3 Diastolic3 Systolic3 Pulse3
Date1 Time4 Diastolic4 Systolic4 Pulse4
Date2 Time1 Diastolic1 Systolic1 Pulse1
Date2 Time2 Diastolic2 Systolic2 Pulse2
Date2 Time3 Diastolic3 Systolic3 Pulse3
Date2 Time4 Diastolic4 Systolic4 Pulse4
...

I would like to convert this table into a new table like this:

Date1 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4
Date2 Time1 Diastolic1 Systolic1 Pulse1 Time2 Diastolic2 Systolic2 Pulse2 Time3 Diastolic3 Systolic3 Pulse3 Time4 Diastolic4 Systolic4 Pulse4
....

Essentially, I want to calculate min, max, and average of columns for different periods of the day to understand the impact of BP medicine and help my doctor better titrate the medicine. Thanks for any hints you can share.

[JanineOWilkins]

I have a question not related to this video, but you said to ask! How can I make a list of dates with matching days in another column....but only Monday-Friday ? Is that too easy? I do this every month and think there's got to be an easier way than dragging and then deleting the

[jaffarmajeed-icxz]

great but need power query more videos