Trying to combine multiple cells in multiple lines to one line with same cells as original

**StormyMondayMel** · 05-25-2023, 05:36 AM

Hope this makes sense, I don't know the lingo. I have a workbook with about 800 enrty rows of data. Each row represents a purchased item in this case and event ticket. So If I buy 2 tickets, the report sends out date showing 2 rows, each for one ticket, the price, fees, donations, etc are the same for both rows, the rows are identical so if I try to take this data and plug it into any kind of summary report or pivot table, the sums I get at the end are many times the actual sales. For example if I bought half a dozen cookies and they were $1 each resulting an amount due of $6 but the bakery put each cookie in a seperate bag and each bah had a copy of the receipt for the whole order, If I take the cookie receipts and try to put them together to find out how much my cookies were there are 6 receipts each saying I owe 6 dollars so I records that I spent $36 on cookies! This is what is happening in my excel sheet. I need to take these multiple entry rows and return a single row that lists the quantity of cookies in the original rows but only the price once since it per order not per cookie. I hope this makes sense to someone, help please

**etaf** · 05-25-2023, 05:40 AM

you maybe able to setup a new column which divides by the count of rows - but need to see the data in a sample
so if an order number then count the order numbers in the column and divide by the total

6 orders - would be the count of receipts = 6
amount would be $6 and then divide that by the count - back to 1 - now you can use pivot or other dashboard calculations

A sample sheet would help here, and possibly will enable a quicker and more accurate solution for you.

The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Trying to combine multiple cells in multiple lines to one line with same cells as original

LinkBack

Thread Tools

Rate This Thread

Display

Trying to combine multiple cells in multiple lines to one line with same cells as original

Re: Trying to combine multiple cells in multiple lines to one line with same cells as orig

Thread Information

Users Browsing this Thread

Similar Threads

Copying spreadsheet with multiple cells that contain multiple lines.

[SOLVED] How to alter the format of a referenced cell: from multiple lines/cells to one line.

[SOLVED] Want to convert multiple lines of data in single cell to multiple cells with single lines

How to combine data from multiple lines into one line

[SOLVED] Combine values from multiple cells into one cell, then delete duplicate lines

Combine multiple vertical cells into one cell formatted with line breaks, left justified

Automatically Combine Multiple Cells Into One Cell Formatted With Line Breaks Between Each

Bookmarks

Bookmarks

Posting Permissions