My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

You are here: Home / Combining Rows and moving service provided to columns|General Excel Questions & Answers|Excel Forum|My Online Training Hub
Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search|Last Search Results
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Combining Rows and moving service provided to columns
Avatar
Todd Grady
Member
Members
Level 0
Forum Posts: 8
Member Since:
March 29, 2019
sp_UserOfflineSmall Offline
1
March 29, 2019 - 4:03 am
sp_Permalink sp_Print

I have client data that is in rows in a table  Example:

Anderson   3 units $5.00 per unit $15.00

Anderson   6 units $18.00 per unit $108.00

Anderson   3 units $3.23 per unit $9.69

 

I have about 2000 rows.  Each client can have anywhere from one row to four rows. 

 

I want to have

Anderson  3  $5.00    6 $18.00   3 $3.23

I want the units and price in different columns all in the same row.  I am trying to mail merge the units and cost into a letter.  Thanks for any help.

sp_AnswersTopicSeeAnswer See Answer
Avatar
SunnyKow
Puchong, Malaysia

VIP
Members


Trusted Members
Level 8
Forum Posts: 1432
Member Since:
June 25, 2016
sp_UserOfflineSmall Offline
2
March 29, 2019 - 9:18 am
sp_Permalink sp_Print

Hi Todd

Please attach a workbook with sample data for us to take a look.

Avatar
Todd Grady
Member
Members
Level 0
Forum Posts: 8
Member Since:
March 29, 2019
sp_UserOfflineSmall Offline
3
March 29, 2019 - 8:53 pm
sp_Permalink sp_Print

Hello,

I added a sample.  I just want one row per client and multiple columns for each service.  Clients might have one row, or up to 4 rows.  Each service is a different report and I have no control how the reports are produced. 

I am using the power query to pull them together.

 

Thanks for any help.. 

Avatar
Anders Sehlstedt
Eskilstuna, Sweden

VIP
Members


Trusted Members
Level 3
Forum Posts: 871
Member Since:
December 7, 2016
sp_UserOfflineSmall Offline
4
March 30, 2019 - 2:51 am
sp_Permalink sp_Print

Hi,

You can get that using Pivot Table. See attached.

Br,
Anders

sp_AnswersTopicAnswer
Answers Post
Avatar
Todd Grady
Member
Members
Level 0
Forum Posts: 8
Member Since:
March 29, 2019
sp_UserOfflineSmall Offline
5
March 31, 2019 - 4:05 am
sp_Permalink sp_Print

Thank you very much.  I will try it when I get to the office next week. 

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Catalin Bombea, Kim Knox, Nada Perovic, Othman AL MUTAIRI
Guest(s) 2
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 871
Purfleet: 412
Frans Visser: 346
David_Ng: 306
lea cohen: 219
Jessica Stewart: 205
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Othman AL MUTAIRI
Misael Gutierrez Sr.
Attif Ihsan
Kieran Fee
Murat Hasanoglu
Brett Dryland
Saeed Aldousari
Bhuwan Devkota
Kathryn Patton
Maria Conatser
Forum Stats:
Groups: 3
Forums: 24
Topics: 6222
Posts: 27293

 

Member Stats:
Guest Posters: 49
Members: 31916
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen