how to collect the values from differnt sheets to one and sort them with simialr values.

Chaturvedi, Santosh 430 Reputation points
2026-09-17T10:06:34.27+00:00

(Note all values are fake not real)

Hello -- I have one case.

I need to paste the following content in sheet when is placed in starting seee below-.

All the tabs (sheet, collective1,2,3,4...9)are in one sheet only.

The values from tab Collective _1, 2,3, 4,5, 6, 7,8,9 are reuqred to be gathered in one final sheet. (in front.)

Then after this --> when all values get collected (from all colelctives sheets) must be sorted so that all similar Δσi (⊥) [N/mm2] gets sorted in one group one below each other.

Example : for 64.65: the values for 64.65 from collective 2, 3, 4, 5, 6, 9, 8, 9 shall come below as a group.

Similraly for 61.05 : the values for 61.05 from collective 2, 3, 4, 5, 6, 9, 8, 9 shall come below as a group.

and so on ....

All similar groups shall come one below the other. see below.

KIndly advice

User's image

Microsoft 365 and Office | Excel | For business | Other
0 comments
Answer accepted by question author
Alina Le 5,080 Reputation points Independent Advisor
2026-09-17T12:48:24.65+00:00

Hi,

Based on your example, I would prefer using Power Query for this task.

A possible workflow would be:

  • Load each Collective sheet (Collective_1 through Collective_9) into Power Query.
  • Use Append Queries to combine all Collective sheets into a single table.
  • Sort the combined table by Δσi (⊥) [N/mm²].
  • Load the final result back to the front sheet.

For example, if the source sheets contain:

*Collective_1

64.65

61.05

*Collective_2

64.65

51.95

*Collective_3

64.65

61.05

After appending and sorting, the result would be:

64.65

64.65

64.65

_

61.05

61.05

51.95

51.95

This will place all identical Δσi (⊥) [N/mm²] values together, regardless of which Collective sheet they came from.

If you would like additional guidance from Power Query specialists, I would also recommend posting your workbook structure and expected output in Power Query | Microsoft Fabric Community, where Power Query experts can provide more specific recommendations based on your scenario.

I hope you are able to find a solution that works well for your scenario.

Kind regards,

Was this answer helpful?

2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Chaturvedi, Santosh 430 Reputation points
    2026-09-18T14:51:23.6766667+00:00

    Hello Alina --> Power query is strong tool for this purpose-- I have implemented this-- Many thanks for your support and see you again soon !!

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.