By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,376 Members | 3,024 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,376 IT Pros & Developers. It's quick & easy.

Combining two rows with like data into one row

P: 13
I have created the following crosstab report. I would like to return the data when the Welder, spool# and Weld# are the same on the same row.
Expand|Select|Wrap|Line Numbers
  1. Welder Spool #  Weld #  WPS RT  Tracer  VT
  2.   B7      47      1      112A      1
  3.   B7      47      2      112A      1
  4.   B7      47      3      112A      1
  5.   B7      49      2      112A      1
  6.   B7      49      2      112A      1
  7.   B7      59      1      120       1
  8.   B7      59      1      120       1
  9.   B7      59      2      120       1
  10.   B7      71      2      120       1
  11.   B7      71      3      120       1
  12.   B7      74      8      120       1
  13.   B7      77      3      120       1
  14.   B7      82      3      120       1
  15.   B7      82      4      120       1
  16.   B7      84      3      120       1
  17.   B7      84      3      120       1
  18.   B7      84      5      120       1
  19.   B7      88      1      120       1
  20.   B7     100      5      112A      1
  21.   B7     100      5      112A      1
  22.   B7     100     11      112A      1
  23.   B7     112      4      120       1
  24.   B7     114      3      120       1
  25.   B7     117      1      120       1
  26.   B7     117      2      120       1
  27.   B7     117      7      120       1
  28.   B7     138      2      120       1
  29.   B7     149      2      120       1
  30.   B7     190      7      168       1
  31.   B7     190      8      168       1
  32.   B7     201      3      120       1
  33.   B7     213      3      120       1
  34.   B7     213      4      120       1
  35.   B7     217      2      120       1
  36.   B7     237      1      120       1
  37.   B7     237      2      120       1
  38.   B7     237      3      120       1
  39.   B7     292      4      120       1
  40.   B7     292      5      120       1
Oct 18 '18 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,494
Unfortunately you don't indicate in the question what you want done with the other data. I assume you aren't going to suggest we simply show it, as that would be beyond dumb, but until you say what you do want we will struggle to help.

The Tracer VT can be summed or averaged or various other ways used, but many wouldn't work well or at all for the textual data under WPS RT.
Oct 19 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.