Excel - Automate Copying Row Values to Column (8K Data) - Efficient Methods & Tips

Hello,

I need to copy the row values (for example marked in yellow to the place on the right also marked in yellow) to another place in the column. I have 8 thousand data. Is there a way not to do it manually, but somehow automatically? Thanks for the hints.

I understand that you want to sum up e.g. consumption from a specific location, if so, use the BD SUM function, I settled phone calls in the company in this way

and how to do not manually copy each cell from the water meter readings to be settled (and the table on the left to the table on the right)?

And isn't it better to do it in the form of a PivotTable? You select a data region and create a PivotTable. In it you can set any criteria.

nata_lie1987 wrote:

Is there a way not to do it manually, but somehow automatically?

In my opinion, the best way to sum "in different sections" here will be to use the function: SUMIFS (sum_range, criteria_range1, criteria, criteria_range, criteria2 ... .

The sum of the conditions will not work here because each position is different.

Validation point to the list and mark the column A: A

In the cell below index () with the entire table and as a row specify the position () where the argument is the selected location and zero as the last parameter.

added after a while
---------------------------------------
Below is an example of my proposal - you only change the yellow cell.

marek003 wrote:

The sum of the conditions will not work here because each position is different.

However, he maintains his original opinion

It is precisely for the analysis of water consumption in multi-apartment buildings - "unsubscribe - paint" the sum of conditions perfectly fits (I used it myself for such purposes ).

For the data provided by the author of the post (unfortunately in the photo: cunning this analysis can be performed as shown in the screenshot:
sumwar.JPG Download (122.64 kB)

In the attached file, apart from the obvious summing formula, there is also a dynamic address selection list installed
zużyci..lsx Download (11.96 kB)Points: 2 for user

Thanks for the answers. I will test what works in a moment

After analyzing, I have the following conclusions:
The sum of the conditions will not work for me, because I need to write down each water meter separately and do not connect hot water in the kitchen with hot water in the bathroom. There must be each one separately.
"Validation point to list and mark column A: A" - I'm not sure why it should be A: A. If I wrote this in Excel, it throws me an error. Do I have to enter +1 in the formula for each apartment? I will send an excel file so that it is known how many apartments I have, and here, for example, one block

Probably due to limited knowledge of Excel - your friend's conclusions are wrong

Both the first and the second method, after minor modifications to the formulas, enable the search for individual indications.

"Index" method
2017-11...png Download (47.47 kB)

"Conditional sum" method
2017-11-2..1).png Download (32.79 kB)

However, it seems to me that when it comes to searching for individual consumption indications - the easiest way is to use the auto-filtering or advanced filtering method.

nata_lie wrote:

I need each water meter to write out separately and not to connect the hot water in the kitchen with hot water in the bathroom. There must be each one separately.

Kobitki, such fags are a bit ... ...

"Making life easier" - add one column in the "Sheet1" sheet to the "index" listing the "address-indications" of water meters, e.g. in the "E" column - and so some columns are added there, one more is not will be troublesome.
In the sheet '' Sheet2 '' make a "nice table with only one function" - '' Vertical Search '' ... and by the way "pick up" your friends Prot and marek003 their 'Index' function ...
Search on the previously prepared "index".

Add yourself a few "ornaments":
1) creating a correctness list
2) updating the correctness list: opening the file, activating the page with the read preview and double-clicking a specific cell - check what suits you best and delete unnecessary procedures.

And it should "look somehow" ... maybe ...
Odczyt_Pom...kie_v2.zip Download (37.18 kB)Points: 1 for user