返回目录：excel表格制作
Excel如何转换行和列数据？
选中目标单元的区域，复制行转列的数据，选择要粘贴的列，点右键，点选择性粘贴～点转置～点确定～完成
{!-- PGC_VIDEO:{"thumb_height": 360, "thumb_url": "2c45d0001593b24efc4b5", "vname": "", "vid": "v02016880000bkvfv5b6936gt3vdgrgg", "thumb_width": 640, "src_thumb_uri": "2c45d0001593b24efc4b5", "sp": "toutiao", "update_thumb_type": 1, "vposter": "http://p1.toutiaoimg.com/origin/2c45d0001593b24efc4b5", "video_size": {"high": {"duration": 64.714, "h": 480, "subjective_score": 0, "w": 854, "file_size": 6740488}, "ultra": {"duration": 64.714, "h": 720, "subjective_score": 0, "w": 1280, "file_size": 21225410}, "normal": {"duration": 64.714, "h": 360, "subjective_score": 0, "w": 640, "file_size": 3190064}}, "md5": "bd346a4702385d886c5e788d0fb819e4", "duration": 64.714, "file_sign": "bd346a4702385d886c5e788d0fb819e4", "thumb_uri": "2c45d0001593b24efc4b5", "vu": "v02016880000bkvfv5b6936gt3vdgrgg"} --}