×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Creating a layout of values?

Creating a layout of values?

Creating a layout of values?

(OP)
Hello.

Overall Situation:
From my initial 2 columns of information 1 being Panel (number) and the 2 with Reinforcing (number) create data that shows all the panels for a specific reinforcing number.

The way I do it right now is have the two columns then beside them use a formula to get the cell value next to it and fill down.  Then I manualy delete the extra reinf numbers and then cut/paste panels into proper cells going from left to right.

We have to re-create panels and reinforcing numbers for everyjob so I would like to automate this.


Here is an example of what it comes out as.
http://www.homenkobuilders.com/reinf.gif


I know there is an easy way to do this but I can't figure it at the moment.

Thanks

Matt

RE: Creating a layout of values?

A pivot table is probably the best solution for you. Select your data columns, then choose Data / Pivot table from the menu. Then define the table the way you like it best.
For example, place the reinforcments in the column headers, and the panels in the rows, and Count of reinforcements in the body of the table. You should get a matrix, with non-zero values where you have a combination defined.
Alternatively, place the reinforcements as the first row source, and the panels as the second row source (you can drag & drop once the pivot table is defined). The list should line up pretty much the way you did it by hand.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources