2026年9月11日星期五

Excel Consolidate Data

Click Product (red)
Go to Data Tab > Consolidate
Add reference tables One-by-One
At the window of Consolidate
Under Reference, click on the blank
1) Choose the area of two column with multiple row
2) Then, click Add
Repeating step 1 & 2
After done add reference, click the box of Top row & Left column
Click OK



没有评论:

发表评论

注意:只有此博客的成员才能发布评论。